Back to Main Menu

Bulk SMP configuration import

Process

Fill in the template or extract the data

  1. Ensure the minimum set of fields is not blank.
  2. Ideally the list should only contain new items.

Import the template

  1. Use SQL management studio to import the template into a table called [SMP_SimpleImport]

Run the migration script

Scripts

Extraction script for getting config from a client

 

Migration script

ImportSMPConfig.sql

Import template